<!DOCTYPE html><html lang="zh-CN"><head><meta name="generator" content="Hexo 3.8.0"><meta name="google-site-verification" content="wD1H9sqEoDWmIBFt7TjlgbVqcJqiqpwR2Wq7_bvEHcE"><meta name="baidu-site-verification" content="RZErJH3v0Z"><meta charset="utf-8"><link rel="icon" href="/css/images/my_logo.png" type="image/x-icon"><title>Activiti 23张表及7大服务详解 | ArtIsLong的博客</title><meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1"><meta name="description" content="近来要做流程项目了，由于上大学的时候学过BPMN，现在重新入手Activiti，感觉还是比较容易的，此文先将Activiti6相关的服务接口及相关表略做记录，方便以后查看。"><meta name="keywords" content="工作流"><meta property="og:type" content="article"><meta property="og:title" content="Activiti 23张表及7大服务详解"><meta property="og:url" content="/2018/07/28/Activiti-23张表及7大服务详解/index.html"><meta property="og:site_name" content="ArtIsLong的博客"><meta property="og:description" content="近来要做流程项目了，由于上大学的时候学过BPMN，现在重新入手Activiti，感觉还是比较容易的，此文先将Activiti6相关的服务接口及相关表略做记录，方便以后查看。"><meta property="og:locale" content="zh-CN"><meta property="og:image" content="https://artislong.oss-cn-hangzhou.aliyuncs.com/images/%E5%BE%AE%E4%BF%A1%E5%85%AC%E4%BC%97%E5%8F%B7/%E5%BE%AE%E4%BF%A1%E5%85%AC%E4%BC%97%E5%8F%B71.png"><meta property="og:updated_time" content="2019-11-05T03:30:23.337Z"><meta name="twitter:card" content="summary"><meta name="twitter:title" content="Activiti 23张表及7大服务详解"><meta name="twitter:description" content="近来要做流程项目了，由于上大学的时候学过BPMN，现在重新入手Activiti，感觉还是比较容易的，此文先将Activiti6相关的服务接口及相关表略做记录，方便以后查看。"><meta name="twitter:image" content="https://artislong.oss-cn-hangzhou.aliyuncs.com/images/%E5%BE%AE%E4%BF%A1%E5%85%AC%E4%BC%97%E5%8F%B7/%E5%BE%AE%E4%BF%A1%E5%85%AC%E4%BC%97%E5%8F%B71.png"><link rel="alternate" href="/atom.xml" title="ArtIsLong的博客" type="application/atom+xml"><link rel="stylesheet" href="/libs/font-awesome5/css/fontawesome.min.css"><link rel="stylesheet" href="/libs/font-awesome5/css/fa-brands.min.css"><link rel="stylesheet" href="/libs/font-awesome5/css/fa-solid.min.css"><link rel="stylesheet" href="/libs/open-sans/styles.css"><link rel="stylesheet" href="/libs/source-code-pro/styles.css"><link rel="stylesheet" href="/css/style.css"><script src="/libs/jquery/2.1.3/jquery.min.js"></script><link rel="stylesheet" href="/libs/lightgallery/css/lightgallery.min.css"><link rel="stylesheet" href="/libs/justified-gallery/justifiedGallery.min.css"><script>var _hmt=_hmt||[];!function(){var e=document.createElement("script");e.src="//hm.baidu.com/hm.js?b59777544dd5d59ce94e191bac62427c";var t=document.getElementsByTagName("script")[0];t.parentNode.insertBefore(e,t)}()</script><script>!function(){var t=document.createElement("script"),e=window.location.protocol.split(":")[0];t.src="https"===e?"https://zz.bdstatic.com/linksubmit/push.js":"http://push.zhanzhang.baidu.com/push.js";var s=document.getElementsByTagName("script")[0];s.parentNode.insertBefore(t,s)}()</script><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script><script>(adsbygoogle=window.adsbygoogle||[]).push({google_ad_client:"ca-pub-4444107320537106",enable_page_level_ads:!0})</script></head></html><body><div id="container"><header id="header"><div id="header-main" class="header-inner"><div class="outer"><a href="/" id="logo"><i class="logo"></i> <span class="site-title">ArtIsLong的博客</span></a><nav id="main-nav"> <a class="main-nav-link" href="/.">首页</a> <a class="main-nav-link" href="/archives">归档</a> <a class="main-nav-link" href="/books">书架</a> <a class="main-nav-link" href="/about">关于我</a></nav><nav id="sub-nav"><div class="profile" id="profile-nav"> <a id="profile-anchor" href="javascript:;"><img class="avatar" src="/css/images/head.png"><i class="fas fa-caret-down"></i></a></div></nav><div id="search-form-wrap"><form class="search-form"> <input type="text" class="ins-search-input search-form-input" placeholder="搜索"> <button type="submit" class="search-form-submit"></button></form><div class="ins-search"><div class="ins-search-mask"></div><div class="ins-search-container"><div class="ins-input-wrapper"> <input type="text" class="ins-search-input" placeholder="想要查找什么..."><span class="ins-close ins-selectable"><i class="fas fa-times-circle"></i></span></div><div class="ins-section-wrapper"><div class="ins-section-container"></div></div></div></div><script>window.INSIGHT_CONFIG={TRANSLATION:{POSTS:"文章",PAGES:"页面",CATEGORIES:"分类",TAGS:"标签",UNTITLED:"(未命名)"},ROOT_URL:"/",CONTENT_URL:"/content.json"}</script><script src="/js/insight.js"></script></div></div></div><div id="main-nav-mobile" class="header-sub header-inner"><table class="menu outer"><tr><td><a class="main-nav-link" href="/.">首页</a></td><td><a class="main-nav-link" href="/archives">归档</a></td><td><a class="main-nav-link" href="/books">书架</a></td><td><a class="main-nav-link" href="/about">关于我</a></td><td><div class="search-form"> <input type="text" class="ins-search-input search-form-input" placeholder="搜索"></div></td></tr></table></div></header><div class="outer"><aside id="profile" class="profile-fixed"><div class="inner profile-inner"><div class="base-info profile-block"> <a href="/"><img id="avatar" src="/css/images/head.png"></a><h2 id="name">ArtIsLong</h2><h3 id="title">不吹牛，不装逼，只做最单纯的技术分享</h3><span id="location"><i class="fas fa-map-marker-alt" style="padding-right:5px"></i> Shanghai, China</span> <a id="follow" target="_blank" href="https://github.com/ArtIsLong">关注我</a></div><div class="article-info profile-block"><div class="article-info-block"> 39 <span>文章</span></div><div class="article-info-block"> 30 <span>标签</span></div></div><div class="profile-block social-links"><table><tr><td><a href="http://github.com/ArtIsLong" target="_blank" title="Github" class="tooltip"><i class="fab fa-github"></i></a></td><td> <a href="https://gitee.com/artislong" target="_blank" title="Gitee" class="tooltip"><i class="fab"><img src="https://gitee.com/artislong/artislong/widgets/widget_5.svg" style="height:25px;margin-bottom:-5px"></i></a></td><td> <a href="https://www.jianshu.com/u/46d989a94f20" target="_blank" title="简书" class="tooltip"><i class="fab"><span style="height:25px;margin-bottom:-5px;color:#ff8c00">简</span></i></a></td><td> <a href="mailto:chenmin049@163.com" target="_blank" title="E-Mail" class="tooltip"><i class="fab"><span style="height:25px;width:20px;margin-bottom:-5px;color:#1e90ff;font-size:16px">Mail</span></i></a></td><td><a href="/atom.xml" target="_blank" title="RSS" class="tooltip"><i class="fas fa-rss"></i></a></td></tr></table></div></div></aside><section id="main"><article id="post-Activiti-23张表及7大服务详解" class="article article-type-post" itemscope="" itemprop="blogPost"><div class="article-inner"><header class="article-header"><h1 class="article-title" itemprop="name"> Activiti 23张表及7大服务详解</h1><div class="article-meta"><div class="article-date"><i class="fas fa-calendar-alt"></i> <a href="/2018/07/28/Activiti-23张表及7大服务详解/"><time datetime="2018-07-28T15:43:07.000Z" itemprop="datePublished">2018-07-28 23:43:07</time></a></div><div class="article-category"><i class="fas fa-folder"></i> <a class="article-category-link" href="/categories/工作流/">工作流</a><i class="fas fa-angle-right"></i><a class="article-category-link" href="/categories/工作流/Activiti/">Activiti</a></div><div class="article-tag"><i class="fas fa-tag"></i> <a class="tag-link" href="/tags/工作流/">工作流</a></div><div style="font-size:12px"><span id="busuanzi_container_page_pv">阅读次数：<span id="busuanzi_value_page_pv"></span></span></div></div></header><div class="article-entry" itemprop="articleBody"><div id="toc" class="toc-article"> <strong class="toc-title">文章目录</strong><ol class="toc"><li class="toc-item toc-level-3"><a class="toc-link" href="#7大服务介绍"><span class="toc-number">1.</span> <span class="toc-text">7大服务介绍</span></a></li><li class="toc-item toc-level-3"><a class="toc-link" href="#23张表概览"><span class="toc-number">2.</span> <span class="toc-text">23张表概览</span></a></li><li class="toc-item toc-level-3"><a class="toc-link" href="#23张表详解"><span class="toc-number">3.</span> <span class="toc-text">23张表详解</span></a><ol class="toc-child"><li class="toc-item toc-level-4"><a class="toc-link" href="#二进制数据表（act-ge-bytearray）"><span class="toc-number">3.1.</span> <span class="toc-text">二进制数据表（act_ge_bytearray）</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#属性数据表-act-ge-property"><span class="toc-number">3.2.</span> <span class="toc-text">属性数据表(act_ge_property)</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#历史节点表（act-hi-actinst）"><span class="toc-number">3.3.</span> <span class="toc-text">历史节点表（act_hi_actinst）</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#历史附件表-act-hi-attachment"><span class="toc-number">3.4.</span> <span class="toc-text">历史附件表( act_hi_attachment )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#历史意见表-act-hi-comment"><span class="toc-number">3.5.</span> <span class="toc-text">历史意见表( act_hi_comment )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#历史详情表-act-hi-detail"><span class="toc-number">3.6.</span> <span class="toc-text">历史详情表( act_hi_detail )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#历史流程人员表-act-ru-identitylink"><span class="toc-number">3.7.</span> <span class="toc-text">历史流程人员表( act_ru_identitylink )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#历史流程实例表（act-hi-procinst）"><span class="toc-number">3.8.</span> <span class="toc-text">历史流程实例表（act_hi_procinst）</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#历史任务实例表-act-hi-taskinst"><span class="toc-number">3.9.</span> <span class="toc-text">历史任务实例表( act_hi_taskinst )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#历史变量表-act-hi-varinst"><span class="toc-number">3.10.</span> <span class="toc-text">历史变量表( act_hi_varinst )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#用户组信息表-act-id-group"><span class="toc-number">3.11.</span> <span class="toc-text">用户组信息表( act_id_group )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#用户扩展信息表-act-id-info"><span class="toc-number">3.12.</span> <span class="toc-text">用户扩展信息表( act_id_info )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#用户与分组对应信息表-act-id-membership"><span class="toc-number">3.13.</span> <span class="toc-text">用户与分组对应信息表( act_id_membership )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#用户信息表-act-id-user"><span class="toc-number">3.14.</span> <span class="toc-text">用户信息表( act_id_user )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#部署信息表-act-re-deployment"><span class="toc-number">3.15.</span> <span class="toc-text">部署信息表( act_re_deployment )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#流程设计模型部署表-act-re-model"><span class="toc-number">3.16.</span> <span class="toc-text">流程设计模型部署表( act_re_model )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#流程定义数据表-act-re-procdef"><span class="toc-number">3.17.</span> <span class="toc-text">流程定义数据表( act_re_procdef )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#act-ru-event-subscr"><span class="toc-number">3.18.</span> <span class="toc-text">act_ru_event_subscr</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#运行时流程执行实例表-act-ru-execution"><span class="toc-number">3.19.</span> <span class="toc-text">运行时流程执行实例表( act_ru_execution )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#运行时流程人员表-act-ru-identitylink"><span class="toc-number">3.20.</span> <span class="toc-text">运行时流程人员表( act_ru_identitylink )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#运行时定时任务数据表-act-ru-job"><span class="toc-number">3.21.</span> <span class="toc-text">运行时定时任务数据表( act_ru_job )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#运行时任务节点表-act-ru-task"><span class="toc-number">3.22.</span> <span class="toc-text">运行时任务节点表( act_ru_task )</span></a></li><li class="toc-item toc-level-4"><a class="toc-link" href="#运行时流程变量数据表-act-ru-variable"><span class="toc-number">3.23.</span> <span class="toc-text">运行时流程变量数据表( act_ru_variable )</span></a></li></ol></li></ol></div><p>近来要做流程项目了，由于上大学的时候学过BPMN，现在重新入手Activiti，感觉还是比较容易的，此文先将Activiti6相关的服务接口及相关表略做记录，方便以后查看。<br><a id="more"></a></p><h3 id="7大服务介绍"><a href="#7大服务介绍" class="headerlink" title="7大服务介绍"></a>7大服务介绍</h3><table><thead><tr><th>服务名称</th><th>描述</th></tr></thead><tbody><tr><td>RepositoryService</td><td>Activiti 中每一个不同版本的业务流程的定义都需要使用一些定义文件，部署文件和支持数据 ( 例如 BPMN2.0 XML 文件，表单定义文件，流程定义图像文件等 )，这些文件都存储在 Activiti 内建的 Repository 中。Repository Service 提供了对 repository 的存取服务。</td></tr><tr><td>RuntimeService</td><td>在 Activiti 中，每当一个流程定义被启动一次之后，都会生成一个相应的流程对象实例。Runtime Service 提供了启动流程、查询流程实例、设置获取流程实例变量等功能。此外它还提供了对流程部署，流程定义和流程实例的存取服务。</td></tr><tr><td>TaskService</td><td>在 Activiti 中业务流程定义中的每一个执行节点被称为一个 Task，对流程中的数据存取，状态变更等操作均需要在 Task 中完成。Task Service 提供了对用户 Task 和 Form 相关的操作。它提供了运行时任务查询、领取、完成、删除以及变量设置等功能。</td></tr><tr><td>IdentityService</td><td>Activiti 中内置了用户以及组管理的功能，必须使用这些用户和组的信息才能获取到相应的 Task。Identity Service 提供了对 Activiti 系统中的用户和组的管理功能。</td></tr><tr><td>ManagementService</td><td>Management Service 提供了对 Activiti 流程引擎的管理和维护功能，这些功能不在工作流驱动的应用程序中使用，主要用于 Activiti 系统的日常维护。</td></tr><tr><td>HistoryService</td><td>History Service 用于获取正在运行或已经完成的流程实例的信息，与 Runtime Service 中获取的流程信息不同，历史信息包含已经持久化存储的永久信息，并已经被针对查询优化。</td></tr><tr><td>FormService</td><td>Activiti 中的流程和状态 Task 均可以关联业务相关的数据。通过使用 Form Service 可以存取启动和完成任务所需的表单数据并且根据需要来渲染表单。</td></tr></tbody></table><h3 id="23张表概览"><a href="#23张表概览" class="headerlink" title="23张表概览"></a>23张表概览</h3><p>Activiti使用到的表都是ACT_开头的。</p><ul><li><p>ACT_RE_*:</p><p>’RE’表示repository(存储)，RepositoryService接口所操作的表。带此前缀的表包含的是静态信息，如，流程定义，流程的资源（图片，规则等）。</p></li><li><p>ACT_RU_*:</p><p>‘RU’表示runtime，运行时表-RuntimeService。这是运行时的表存储着流程变量，用户任务，变量，职责（job）等运行时的数据。Activiti只存储实例执行期间的运行时数据，当流程实例结束时，将删除这些记录。这就保证了这些运行时的表小且快。</p></li><li><p>ACT_ID_*:</p><p>’ID’表示identity (组织机构)，IdentityService接口所操作的表。用户记录，流程中使用到的用户和组。这些表包含标识的信息，如用户，用户组，等等。</p></li><li><p>ACT_HI_*:</p><p>’HI’表示history，历史数据表，HistoryService。就是这些表包含着流程执行的历史相关数据，如结束的流程实例，变量，任务，等等</p></li><li><p>ACT_GE_*:</p><p>全局通用数据及设置(general)，各种情况都使用的数据。</p></li></ul><table><thead><tr><th>序号</th><th>表名</th><th>说明</th></tr></thead><tbody><tr><td>1</td><td>act_ge_bytearray</td><td>二进制数据表</td></tr><tr><td>2</td><td>act_ge_property</td><td>属性数据表存储整个流程引擎级别的数据,初始化表结构时，会默认插入三条记录，</td></tr><tr><td>3</td><td>act_hi_actinst</td><td>历史节点表</td></tr><tr><td>4</td><td>act_hi_attachment</td><td>历史附件表</td></tr><tr><td>5</td><td>act_hi_comment</td><td>历史意见表</td></tr><tr><td>6</td><td>act_hi_identitylink</td><td>历史流程人员表</td></tr><tr><td>7</td><td>act_hi_detail</td><td>历史详情表，提供历史变量的查询</td></tr><tr><td>8</td><td>act_hi_procinst</td><td>历史流程实例表</td></tr><tr><td>9</td><td>act_hi_taskinst</td><td>历史任务实例表</td></tr><tr><td>10</td><td>act_hi_varinst</td><td>历史变量表</td></tr><tr><td>11</td><td>act_id_group</td><td>用户组信息表</td></tr><tr><td>12</td><td>act_id_info</td><td>用户扩展信息表</td></tr><tr><td>13</td><td>act_id_membership</td><td>用户与用户组对应信息表</td></tr><tr><td>14</td><td>act_id_user</td><td>用户信息表</td></tr><tr><td>15</td><td>act_re_deployment</td><td>部署信息表</td></tr><tr><td>16</td><td>act_re_model</td><td>流程设计模型部署表</td></tr><tr><td>17</td><td>act_re_procdef</td><td>流程定义数据表</td></tr><tr><td>18</td><td>act_ru_event_subscr</td><td>throwEvent、catchEvent时间监听信息表</td></tr><tr><td>19</td><td>act_ru_execution</td><td>运行时流程执行实例表</td></tr><tr><td>20</td><td>act_ru_identitylink</td><td>运行时流程人员表，主要存储任务节点与参与者的相关信息</td></tr><tr><td>21</td><td>act_ru_job</td><td>运行时定时任务数据表</td></tr><tr><td>22</td><td>act_ru_task</td><td>运行时任务节点表</td></tr><tr><td>23</td><td>act_ru_variable</td><td>运行时流程变量数据表</td></tr></tbody></table><h3 id="23张表详解"><a href="#23张表详解" class="headerlink" title="23张表详解"></a>23张表详解</h3><h4 id="二进制数据表（act-ge-bytearray）"><a href="#二进制数据表（act-ge-bytearray）" class="headerlink" title="二进制数据表（act_ge_bytearray）"></a>二进制数据表（act_ge_bytearray）</h4><p>保存流程定义图片和xml、Serializable(序列化)的变量,即保存所有二进制数据，特别注意类路径部署时候，不要把svn等隐藏文件或者其他与流程无关的文件也一起部署到该表中，会造成一些错误（可能导致流程定义无法删除）</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>Y</td><td></td><td>主键ID</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>Y</td><td>Version(版本)</td></tr><tr><td>NAME_</td><td>名称</td><td>nvarchar(255)</td><td></td><td>Y</td><td>部署的文件名称，如：leave.bpmn.png,leave.bpmn20.xml</td></tr><tr><td>DEPLOYMENT_ID_</td><td>部署ID</td><td>nvarchar(64)</td><td></td><td>Y</td><td>部署表ID</td></tr><tr><td>BYTES_</td><td>字节</td><td>varbinary(max)</td><td></td><td>Y</td><td>部署文件</td></tr><tr><td>GENERATED_</td><td>是否是引擎生成</td><td>tinyint</td><td></td><td>Y</td><td>0为用户生成，1为activiti生成</td></tr></tbody></table><h4 id="属性数据表-act-ge-property"><a href="#属性数据表-act-ge-property" class="headerlink" title="属性数据表(act_ge_property)"></a>属性数据表(act_ge_property)</h4><p>属性数据表。存储整个流程引擎级别的数据。</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>NAME_</td><td>名称</td><td>nvarchar(64)</td><td>√</td><td></td><td>schema.versionschema.historynext.dbid</td></tr><tr><td>VALUE_</td><td>值</td><td>nvarchar(300)</td><td></td><td>√</td><td>5.<em>create(5.</em>)</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>version</td></tr></tbody></table><h4 id="历史节点表（act-hi-actinst）"><a href="#历史节点表（act-hi-actinst）" class="headerlink" title="历史节点表（act_hi_actinst）"></a>历史节点表（act_hi_actinst）</h4><p>历史活动信息。这里记录流程流转过的所有节点，与HI_TASKINST不同的是，taskinst只记录usertask内容</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td></td></tr><tr><td>PROC_DEF_ID_</td><td>流程定义ID</td><td>nvarchar(64)</td><td></td><td></td><td></td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td></td><td></td></tr><tr><td>EXECUTION_ID_</td><td>执行实例ID</td><td>nvarchar(64)</td><td></td><td></td><td></td></tr><tr><td>ACT_ID_</td><td>节点ID</td><td>nvarchar(225)</td><td></td><td></td><td>节点定义ID</td></tr><tr><td>TASK_ID_</td><td>任务实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>任务实例ID 其他节点类型实例ID在这里为空</td></tr><tr><td>CALL_PROC_INST_ID_</td><td>调用外部的流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>调用外部流程的流程实例ID’</td></tr><tr><td>ACT_NAME_</td><td>节点名称</td><td>nvarchar(225)</td><td></td><td>√</td><td>节点定义名称</td></tr><tr><td>ACT_TYPE_</td><td>节点类型</td><td>nvarchar(225)</td><td></td><td></td><td>如startEvent、userTask</td></tr><tr><td>ASSIGNEE_</td><td>签收人</td><td>nvarchar(64)</td><td></td><td>√</td><td>节点签收人</td></tr><tr><td>START_TIME_</td><td>开始时间</td><td>datetime</td><td></td><td></td><td>2013-09-15 11:30:00</td></tr><tr><td>END_TIME_</td><td>结束时间</td><td>datetime</td><td></td><td>√</td><td>2013-09-15 11:30:00</td></tr><tr><td>DURATION_</td><td>耗时</td><td>numeric(19,0)</td><td></td><td>√</td><td>毫秒值</td></tr></tbody></table><h4 id="历史附件表-act-hi-attachment"><a href="#历史附件表-act-hi-attachment" class="headerlink" title="历史附件表( act_hi_attachment )"></a>历史附件表( act_hi_attachment )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键ID</td></tr><tr><td>REV_</td><td>乐观锁</td><td>integer</td><td></td><td>√</td><td>Version</td></tr><tr><td>USER_ID_</td><td>用户ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>用户ID</td></tr><tr><td>NAME_</td><td>名称</td><td>nvarchar(255)</td><td></td><td>√</td><td>附件名称</td></tr><tr><td>DESCRIPTION_</td><td>描述</td><td>nvarchar(4000)</td><td></td><td>√</td><td>描述</td></tr><tr><td>TYPE_</td><td>类型</td><td>nvarchar(255)</td><td></td><td>√</td><td>附件类型</td></tr><tr><td>TASK_ID_</td><td>任务实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>节点实例ID</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>URL_</td><td>URL_</td><td>nvarchar(4000)</td><td></td><td>√</td><td>附件地址</td></tr><tr><td>CONTENT_ID_</td><td>字节表的ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>ACT_GE_BYTEARRAY的ID</td></tr></tbody></table><h4 id="历史意见表-act-hi-comment"><a href="#历史意见表-act-hi-comment" class="headerlink" title="历史意见表( act_hi_comment )"></a>历史意见表( act_hi_comment )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键ID</td></tr><tr><td>TYPE_</td><td>类型</td><td>nvarchar(255)</td><td></td><td>√</td><td>类型：event（事件）comment（意见）</td></tr><tr><td>TIME_</td><td>时间</td><td>datetime</td><td></td><td></td><td>填写时间’</td></tr><tr><td>USER_ID_</td><td>用户ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>填写人</td></tr><tr><td>TASK_ID_</td><td>节点任务ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>节点实例ID</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>ACTION_</td><td>行为类型</td><td>nvarchar(64)</td><td></td><td>√</td><td>见备注1</td></tr><tr><td>MESSAGE_</td><td>基本内容</td><td>nvarchar(4000)</td><td></td><td>√</td><td>用于存放流程产生的信息，比如审批意见</td></tr><tr><td>FULL_MSG_</td><td>全部内容</td><td>varbinary(max)</td><td></td><td>√</td><td>附件地址</td></tr></tbody></table><h4 id="历史详情表-act-hi-detail"><a href="#历史详情表-act-hi-detail" class="headerlink" title="历史详情表( act_hi_detail )"></a>历史详情表( act_hi_detail )</h4><p>流程中产生的变量详细，包括控制流程流转的变量，业务表单中填写的流程需要用到的变量等。</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键</td></tr><tr><td>TYPE_</td><td>类型</td><td>nvarchar(255)</td><td></td><td></td><td>见备注2</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>EXECUTION_ID_</td><td>执行实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>执行实例ID</td></tr><tr><td>TASK_ID_</td><td>任务实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>任务实例ID</td></tr><tr><td>ACT_INST_ID_</td><td>节点实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>ACT_HI_ACTINST表的ID</td></tr><tr><td>NAME_</td><td>名称</td><td>nvarchar(255)</td><td></td><td></td><td>名称</td></tr><tr><td>VAR_TYPE_</td><td>参数类型</td><td>nvarchar(255)</td><td></td><td>√</td><td>见备注3</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>Version</td></tr><tr><td>TIME_</td><td>时间戳</td><td>datetime</td><td></td><td></td><td>创建时间</td></tr><tr><td>BYTEARRAY_ID_</td><td>字节表ID</td><td>nvarchar</td><td></td><td>√</td><td>ACT_GE_BYTEARRAY表的ID</td></tr><tr><td>DOUBLE_</td><td>DOUBLE_</td><td>double precision</td><td></td><td>√</td><td>存储变量类型为Double</td></tr><tr><td>LONG_</td><td>LONG_</td><td>numeric</td><td></td><td>√</td><td>存储变量类型为long</td></tr><tr><td>TEXT_</td><td>TEXT_</td><td>nvarchar</td><td></td><td>√</td><td>存储变量值类型为String</td></tr><tr><td>TEXT2_</td><td>TEXT2_</td><td>nvarchar</td><td></td><td>√</td><td>此处存储的是JPA持久化对象时，才会有值。此值为对象ID</td></tr></tbody></table><h4 id="历史流程人员表-act-ru-identitylink"><a href="#历史流程人员表-act-ru-identitylink" class="headerlink" title="历史流程人员表( act_ru_identitylink )"></a>历史流程人员表( act_ru_identitylink )</h4><p>任务参与者数据表。主要存储历史节点参与者的信息</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>ID_</td></tr><tr><td>GROUP_ID_</td><td>组ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>组ID</td></tr><tr><td>TYPE_</td><td>类型</td><td>nvarchar(255)</td><td></td><td>√</td><td>备注4</td></tr><tr><td>USER_ID_</td><td>用户ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>用户ID</td></tr><tr><td>TASK_ID_</td><td>节点实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>节点实例ID</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr></tbody></table><h4 id="历史流程实例表（act-hi-procinst）"><a href="#历史流程实例表（act-hi-procinst）" class="headerlink" title="历史流程实例表（act_hi_procinst）"></a>历史流程实例表（act_hi_procinst）</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键ID</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td></td><td>流程实例ID</td></tr><tr><td>BUSINESS_KEY_</td><td>业务主键</td><td>nvarchar(255)</td><td></td><td>√</td><td>业务主键，业务表单的ID</td></tr><tr><td>PROC_DEF_ID_</td><td>流程定义ID</td><td>nvarchar(64)</td><td></td><td></td><td>流程定义ID</td></tr><tr><td>START_TIME_</td><td>开始时间</td><td>datetime</td><td></td><td></td><td>开始时间</td></tr><tr><td>END_TIME_</td><td>结束时间</td><td>datetime</td><td></td><td>√</td><td>结束时间</td></tr><tr><td>DURATION_</td><td>耗时</td><td>Numeric(19)</td><td></td><td>√</td><td>耗时</td></tr><tr><td>START_USER_ID_</td><td>起草人</td><td>nvarchar(255)</td><td></td><td>√</td><td>起草人</td></tr><tr><td>START_ACT_ID_</td><td>开始节点ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>起草环节ID</td></tr><tr><td>END_ACT_ID_</td><td>结束节点ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>结束环节ID</td></tr><tr><td>SUPER_PROCESS_INSTANCE_ID_</td><td>父流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>父流程实例ID</td></tr><tr><td>DELETE_REASON_</td><td>删除原因</td><td>nvarchar(4000)</td><td></td><td>√</td><td>删除原因</td></tr></tbody></table><h4 id="历史任务实例表-act-hi-taskinst"><a href="#历史任务实例表-act-hi-taskinst" class="headerlink" title="历史任务实例表( act_hi_taskinst )"></a>历史任务实例表( act_hi_taskinst )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键ID</td></tr><tr><td>PROC_DEF_ID_</td><td>流程定义ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程定义ID</td></tr><tr><td>TASK_DEF_KEY_</td><td>节点定义ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>节点定义ID</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>EXECUTION_ID_</td><td>执行实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>执行实例ID</td></tr><tr><td>NAME_</td><td>名称</td><td>varchar(255)</td><td></td><td>√</td><td>名称</td></tr><tr><td>PARENT_TASK_ID_</td><td>父节点实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>父节点实例ID</td></tr><tr><td>DESCRIPTION_</td><td>描述</td><td>nvarchar(400)</td><td></td><td>√</td><td>描述</td></tr><tr><td>OWNER_</td><td>实际签收人 任务的拥有者</td><td>nvarchar(255)</td><td></td><td>√</td><td>签收人（默认为空，只有在委托时才有值）</td></tr><tr><td>ASSIGNEE_</td><td>签收人或被委托</td><td>nvarchar(255)</td><td></td><td>√</td><td>签收人或被委托</td></tr><tr><td>START_TIME_</td><td>开始时间</td><td>datetime</td><td></td><td></td><td>开始时间</td></tr><tr><td>CLAIM_TIME_</td><td>提醒时间</td><td>datetime</td><td></td><td>√</td><td>提醒时间</td></tr><tr><td>END_TIME_</td><td>结束时间</td><td>datetime</td><td></td><td>√</td><td>结束时间</td></tr><tr><td>DURATION_</td><td>耗时</td><td>numeric(19)</td><td></td><td>√</td><td>耗时</td></tr><tr><td>DELETE_REASON_</td><td>删除原因</td><td>nvarchar(4000)</td><td></td><td>√</td><td>删除原因(completed,deleted)</td></tr><tr><td>PRIORITY_</td><td>优先级别</td><td>int</td><td></td><td>√</td><td>优先级别</td></tr><tr><td>DUE_DATE_</td><td>过期时间</td><td>datetime</td><td></td><td>√</td><td>过期时间，表明任务应在多长时间内完成</td></tr><tr><td>FORM_KEY_</td><td>节点定义的formkey</td><td>nvarchar(255)</td><td></td><td>√</td><td>desinger节点定义的form_key属性</td></tr></tbody></table><h4 id="历史变量表-act-hi-varinst"><a href="#历史变量表-act-hi-varinst" class="headerlink" title="历史变量表( act_hi_varinst )"></a>历史变量表( act_hi_varinst )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>ID_</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>EXECUTION_ID_</td><td>执行实例ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>执行实例ID</td></tr><tr><td>TASK_ID_</td><td>任务实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>任务实例ID</td></tr><tr><td>NAME_</td><td>名称</td><td>nvarchar(64)</td><td></td><td></td><td>参数名称(英文)</td></tr><tr><td>VAR_TYPE_</td><td>参数类型</td><td>varchar(255)</td><td></td><td>√</td><td>备注5</td></tr><tr><td>REV_</td><td>乐观锁</td><td>nvarchar(64)</td><td></td><td>√</td><td>乐观锁 Version</td></tr><tr><td>BYTEARRAY_ID_</td><td>字节表ID</td><td>nvarchar(400)</td><td></td><td>√</td><td>ACT_GE_BYTEARRAY表的主键</td></tr><tr><td>DOUBLE_</td><td>DOUBLE_</td><td>nvarchar(255)</td><td></td><td>√</td><td>存储DoubleType类型的数据</td></tr><tr><td>LONG_</td><td>LONG_</td><td>nvarchar(255)</td><td></td><td>√</td><td>存储LongType类型的数据</td></tr><tr><td>TEXT_</td><td>TEXT_</td><td>datetime</td><td></td><td>√</td><td>备注6</td></tr><tr><td>TEXT2_</td><td>TEXT2_</td><td>datetime</td><td></td><td>√</td><td>此处存储的是JPA持久化对象时，才会有值。此值为对象ID</td></tr></tbody></table><h4 id="用户组信息表-act-id-group"><a href="#用户组信息表-act-id-group" class="headerlink" title="用户组信息表( act_id_group )"></a>用户组信息表( act_id_group )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键ID</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>乐观锁Version</td></tr><tr><td>NAME_</td><td>名称</td><td>nvarchar(255)</td><td></td><td>√</td><td>组名称</td></tr><tr><td>TYPE_</td><td>类型</td><td>nvarchar(255)</td><td></td><td>√</td><td>类型</td></tr></tbody></table><h4 id="用户扩展信息表-act-id-info"><a href="#用户扩展信息表-act-id-info" class="headerlink" title="用户扩展信息表( act_id_info )"></a>用户扩展信息表( act_id_info )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键ID</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>乐观锁Version</td></tr><tr><td>USER_ID_</td><td>用户ID</td><td>nvarchar(64)</td><td></td><td>√</td><td></td></tr><tr><td>TYPE_</td><td>类型</td><td>nvarchar(64)</td><td></td><td>√</td><td></td></tr><tr><td>KEY_</td><td></td><td>nvarchar(255)</td><td></td><td>√</td><td></td></tr><tr><td>VALUE_</td><td></td><td>nvarchar(255)</td><td></td><td>√</td><td></td></tr><tr><td>PASSWORD_</td><td></td><td>Image</td><td></td><td>√</td><td></td></tr><tr><td>PARENT_ID_</td><td></td><td>nvarchar(255)</td><td></td><td>√</td></tr></tbody></table><h4 id="用户与分组对应信息表-act-id-membership"><a href="#用户与分组对应信息表-act-id-membership" class="headerlink" title="用户与分组对应信息表( act_id_membership )"></a>用户与分组对应信息表( act_id_membership )</h4><p>用来保存用户的分组信息。</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>USER_ID</td><td>用户ID</td><td>nvarchar(64)</td><td>√</td><td></td><td></td></tr><tr><td>GROUP_ID</td><td>用户组ID</td><td>nvarchar(64)</td><td>√</td><td></td></tr></tbody></table><h4 id="用户信息表-act-id-user"><a href="#用户信息表-act-id-user" class="headerlink" title="用户信息表( act_id_user )"></a>用户信息表( act_id_user )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键ID</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>乐观锁Version</td></tr><tr><td>FIRST_</td><td>姓</td><td>nvarchar(255)</td><td></td><td>√</td><td></td></tr><tr><td>LAST_</td><td>名</td><td>nvarchar(255)</td><td></td><td>√</td><td></td></tr><tr><td>EMAIL_</td><td>EMAIL_</td><td>nvarchar(255)</td><td></td><td>√</td><td></td></tr><tr><td>PWD_</td><td>密码</td><td>nvarchar(255)</td><td></td><td>√</td><td></td></tr><tr><td>PICTURE_ID_</td><td>图片ID</td><td>nvarchar(64)</td><td></td><td>√</td></tr></tbody></table><h4 id="部署信息表-act-re-deployment"><a href="#部署信息表-act-re-deployment" class="headerlink" title="部署信息表( act_re_deployment )"></a>部署信息表( act_re_deployment )</h4><p>部署流程定义时需要被持久化保存下来的信息。</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键ID</td></tr><tr><td>NAME_</td><td>部署名称</td><td>nvarchar(255)</td><td></td><td>√</td><td>部署文件名</td></tr><tr><td>CATEGORY_</td><td>分类</td><td>nvarchar(255)</td><td></td><td>√</td><td>类别</td></tr><tr><td>DEPLOY_TIME_</td><td>部署时间</td><td>datetime</td><td></td><td>√</td><td>部署时间</td></tr></tbody></table><h4 id="流程设计模型部署表-act-re-model"><a href="#流程设计模型部署表-act-re-model" class="headerlink" title="流程设计模型部署表( act_re_model )"></a>流程设计模型部署表( act_re_model )</h4><p>流程设计器设计流程后，保存数据到该表。</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>ID_</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>乐观锁</td></tr><tr><td>NAME_</td><td>名称</td><td>nvarchar(255)</td><td></td><td>√</td><td>名称</td></tr><tr><td>KEY_</td><td>KEY_</td><td>nvarchar(255)</td><td></td><td>√</td><td>分类，例如：<a href="http://www.mossle.com/docs/activiti/" target="_blank" rel="noopener">http://www.mossle.com/docs/activiti/</a></td></tr><tr><td>CATEGORY_</td><td>分类</td><td>nvarchar(255)</td><td></td><td>√</td><td>分类</td></tr><tr><td>CREATE_TIME_</td><td>创建时间</td><td>datetime</td><td></td><td>√</td><td>创建时间</td></tr><tr><td>LAST_UPDATE_TIME_</td><td>最新修改时间</td><td>datetime</td><td></td><td>√</td><td>最新修改时间</td></tr><tr><td>VERSION_</td><td>版本</td><td>int</td><td></td><td>√</td><td>版本</td></tr><tr><td>META_INFO_</td><td>META_INFO_</td><td>nvarchar(255)</td><td></td><td>√</td><td>以json格式保存流程定义的信息</td></tr><tr><td>DEPLOYMENT_ID_</td><td>部署ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>部署ID</td></tr><tr><td>EDITOR_SOURCE_VALUE_ID_</td><td></td><td>datetime</td><td></td><td>√</td><td></td></tr><tr><td>EDITOR_SOURCE_EXTRA_VALUE_ID_</td><td></td><td>datetime</td><td></td><td>√</td></tr></tbody></table><h4 id="流程定义数据表-act-re-procdef"><a href="#流程定义数据表-act-re-procdef" class="headerlink" title="流程定义数据表( act_re_procdef )"></a>流程定义数据表( act_re_procdef )</h4><p>业务流程定义数据表。此表和ACT_RE_DEPLOYMENT是多对一的关系，即，一个部署的bar包里可能包含多个流程定义文件，每个流程定义文件都会有一条记录在ACT_REPROCDEF表内，每个流程定义的数据，都会对于ACT_GE_BYTEARRAY表内的一个资源文件和PNG图片文件。和ACT_GE_BYTEARRAY的关联是通过程序用ACT_GE_BYTEARRAY.NAME与ACT_RE_PROCDEF.NAME_完成的，在数据库表结构中没有体现。</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>ID_</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>乐观锁</td></tr><tr><td>CATEGORY_</td><td>分类</td><td>nvarchar(255)</td><td></td><td>√</td><td>流程定义的Namespace就是类别</td></tr><tr><td>NAME_</td><td>名称</td><td>nvarchar(255)</td><td></td><td>√</td><td>名称</td></tr><tr><td>KEY_</td><td>定义的KEY</td><td>nvarchar(255)</td><td></td><td></td><td>流程定义ID</td></tr><tr><td>VERSION_</td><td>版本</td><td>int</td><td></td><td></td><td>版本</td></tr><tr><td>DEPLOYMENT_ID_</td><td>部署表ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>部署表ID</td></tr><tr><td>RESOURCE_NAME_</td><td>bpmn文件名称</td><td>nvarchar(4000)</td><td></td><td>√</td><td>流程bpmn文件名称</td></tr><tr><td>DGRM_RESOURCE_NAME_</td><td>png图片名称</td><td>nvarchar(4000)</td><td></td><td>√</td><td>流程图片名称</td></tr><tr><td>DESCRIPTION_</td><td>描述</td><td>nvarchar(4000)</td><td></td><td>√</td><td>描述</td></tr><tr><td>HAS_START_FORM_KEY_</td><td>是否存在开始节点formKey</td><td>tinyint</td><td></td><td>√</td><td>start节点是否存在formKey 0否 1是</td></tr><tr><td>SUSPENSION_STATE_</td><td>是否挂起</td><td>tinyint</td><td></td><td>√</td><td>1 激活 2挂起</td></tr></tbody></table><h4 id="act-ru-event-subscr"><a href="#act-ru-event-subscr" class="headerlink" title="act_ru_event_subscr"></a>act_ru_event_subscr</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>事件ID</td><td>nvarchar(64)</td><td>√</td><td></td><td>事件ID</td></tr><tr><td>REV_</td><td>版本</td><td>int</td><td></td><td>√</td><td>乐观锁Version</td></tr><tr><td>EVENT_TYPE_</td><td>事件类型</td><td>nvarchar(255)</td><td></td><td></td><td>事件类型</td></tr><tr><td>EVENT_NAME_</td><td>事件名称</td><td>nvarchar(255)</td><td></td><td>√</td><td>事件名称</td></tr><tr><td>EXECUTION_ID_</td><td>执行实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>执行实例ID</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>ACTIVITY_ID_</td><td>活动实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>活动实例ID</td></tr><tr><td>CONFIGURATION_</td><td>配置</td><td>nvarchar(255)</td><td></td><td>√</td><td>配置</td></tr><tr><td>CREATED_</td><td>是否创建</td><td>datetime</td><td></td><td></td><td>默认值 当前系统时间戳CURRENT_TIMESTAMP</td></tr></tbody></table><h4 id="运行时流程执行实例表-act-ru-execution"><a href="#运行时流程执行实例表-act-ru-execution" class="headerlink" title="运行时流程执行实例表( act_ru_execution )"></a>运行时流程执行实例表( act_ru_execution )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>ID_</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>乐观锁</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td></td><td>流程实例ID</td></tr><tr><td>BUSINESS_KEY_</td><td>业务主键ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>业务主键ID</td></tr><tr><td>PARENT_ID_</td><td>父节点实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>父节点实例ID</td></tr><tr><td>PROC_DEF_ID_</td><td>流程定义ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程定义ID</td></tr><tr><td>SUPER_EXEC_</td><td>SUPER_EXEC_</td><td>nvarchar(64)</td><td></td><td>√</td><td>SUPER_EXEC_</td></tr><tr><td>ACT_ID_</td><td>节点实例ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>节点实例ID即ACT_HI_ACTINST中ID</td></tr><tr><td>IS_ACTIVE_</td><td>是否存活</td><td>tinyint</td><td></td><td>√</td><td>是否存活</td></tr><tr><td>IS_CONCURRENT_</td><td>是否并行</td><td>tinyint</td><td></td><td>√</td><td>是否为并行(true/false）</td></tr><tr><td>IS_SCOPE_</td><td>IS_SCOPE_</td><td>tinyint</td><td></td><td>√</td><td>IS_SCOPE_</td></tr><tr><td>IS_EVENT_SCOPE_</td><td>IS_EVENT_SCOPE_</td><td>tinyint</td><td></td><td>√</td><td>IS_EVENT_SCOPE_</td></tr><tr><td>SUSPENSION_STATE_</td><td>是否挂起</td><td>tinyint</td><td></td><td>√</td><td>挂起状态 1激活 2挂起</td></tr><tr><td>CACHED_ENT_STATE_</td><td></td><td>int</td><td></td><td>√</td></tr></tbody></table><h4 id="运行时流程人员表-act-ru-identitylink"><a href="#运行时流程人员表-act-ru-identitylink" class="headerlink" title="运行时流程人员表( act_ru_identitylink )"></a>运行时流程人员表( act_ru_identitylink )</h4><p>任务参与者数据表。主要存储当前节点参与者的信息。</p><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>ID_</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>乐观锁</td></tr><tr><td>GROUP_ID_</td><td>组ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>组ID</td></tr><tr><td>TYPE_</td><td>类型</td><td>nvarchar(255)</td><td></td><td>√</td><td>备注7</td></tr><tr><td>USER_ID_</td><td>用户ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>用户ID</td></tr><tr><td>TASK_ID_</td><td>节点实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>节点实例ID</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>PROC_DEF_ID_</td><td>流程定义ID</td><td>nvarchar(255)</td><td></td><td>√</td><td>流程定义ID</td></tr></tbody></table><h4 id="运行时定时任务数据表-act-ru-job"><a href="#运行时定时任务数据表-act-ru-job" class="headerlink" title="运行时定时任务数据表( act_ru_job )"></a>运行时定时任务数据表( act_ru_job )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>标识</td><td>nvarchar(64)</td><td>√</td><td></td><td>标识</td></tr><tr><td>REV_</td><td>版本</td><td>int</td><td></td><td>√</td><td>版本</td></tr><tr><td>TYPE_</td><td>类型</td><td>nvarchar(255)</td><td></td><td></td><td>类型</td></tr><tr><td>LOCK_EXP_TIME_</td><td>锁定释放时间</td><td>datetime</td><td></td><td>√</td><td>锁定释放时间</td></tr><tr><td>LOCK_OWNER_</td><td>挂起者</td><td>nvarchar(255)</td><td></td><td>√</td><td>挂起者</td></tr><tr><td>EXCLUSIVE_</td><td></td><td>bit</td><td></td><td>√</td><td></td></tr><tr><td>EXECUTION_ID_</td><td>执行实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>执行实例ID</td></tr><tr><td>PROCESS_INSTANCE_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>PROC_DEF_ID_</td><td>流程定义ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程定义ID</td></tr><tr><td>RETRIES_</td><td></td><td>int</td><td></td><td>√</td><td></td></tr><tr><td>EXCEPTION_STACK_ID_</td><td>异常信息ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>异常信息ID</td></tr><tr><td>EXCEPTION_MSG_</td><td>异常信息</td><td>nvarchar(4000)</td><td></td><td>√</td><td>异常信息</td></tr><tr><td>DUEDATE_</td><td>到期时间</td><td>datetime</td><td></td><td>√</td><td>到期时间</td></tr><tr><td>REPEAT_</td><td>重复</td><td>nvarchar(255)</td><td></td><td>√</td><td>重复</td></tr><tr><td>HANDLER_TYPE_</td><td>处理类型</td><td>nvarchar(255)</td><td></td><td>√</td><td>处理类型</td></tr><tr><td>HANDLER_CFG_</td><td></td><td>nvarchar(4000)</td><td></td><td>√</td><td>标识</td></tr></tbody></table><h4 id="运行时任务节点表-act-ru-task"><a href="#运行时任务节点表-act-ru-task" class="headerlink" title="运行时任务节点表( act_ru_task )"></a>运行时任务节点表( act_ru_task )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>ID_</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>乐观锁</td></tr><tr><td>EXECUTION_ID_</td><td>执行实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>执行实例ID</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>PROC_DEF_ID_</td><td>流程定义ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程定义ID</td></tr><tr><td>NAME_</td><td>节点定义名称</td><td>nvarchar(255)</td><td></td><td>√</td><td>节点定义名称</td></tr><tr><td>PARENT_TASK_ID_</td><td>父节点实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>父节点实例ID</td></tr><tr><td>DESCRIPTION_</td><td>节点定义描述</td><td>nvarchar(4000)</td><td></td><td>√</td><td>节点定义描述</td></tr><tr><td>TASK_DEF_KEY_</td><td>节点定义的KEY</td><td>nvarchar(255)</td><td></td><td>√</td><td>任务定义的ID</td></tr><tr><td>OWNER_</td><td>实际签收人</td><td>nvarchar(255)</td><td></td><td>√</td><td>拥有者（一般情况下为空，只有在委托时才有值）</td></tr><tr><td>ASSIGNEE_</td><td>签收人或委托人</td><td>nvarchar(255)</td><td></td><td>√</td><td>签收人或委托人</td></tr><tr><td>DELEGATION_</td><td>委托类型</td><td>nvarchar(64)</td><td></td><td>√</td><td>备注8</td></tr><tr><td>PRIORITY_</td><td>优先级别</td><td>int</td><td></td><td>√</td><td>优先级别，默认为：50</td></tr><tr><td>CREATE_TIME_</td><td>创建时间</td><td>datetime</td><td></td><td>√</td><td>创建时间</td></tr><tr><td>DUE_DATE_</td><td>过期时间</td><td>datetime</td><td></td><td>√</td><td>耗时</td></tr><tr><td>SUSPENSION_STATE_</td><td>是否挂起</td><td>int</td><td></td><td>√</td><td>1代表激活 2代表挂起</td></tr></tbody></table><h4 id="运行时流程变量数据表-act-ru-variable"><a href="#运行时流程变量数据表-act-ru-variable" class="headerlink" title="运行时流程变量数据表( act_ru_variable )"></a>运行时流程变量数据表( act_ru_variable )</h4><table><thead><tr><th>字段名称</th><th>字段描述</th><th>数据类型</th><th>主键</th><th>为空</th><th>取值说明</th></tr></thead><tbody><tr><td>ID_</td><td>ID_</td><td>nvarchar(64)</td><td>√</td><td></td><td>主键标识</td></tr><tr><td>REV_</td><td>乐观锁</td><td>int</td><td></td><td>√</td><td>乐观锁</td></tr><tr><td>TYPE_</td><td>类型</td><td>nvarchar(255)</td><td></td><td></td><td>备注9</td></tr><tr><td>NAME_</td><td>名称</td><td>nvarchar(255)</td><td></td><td></td><td>变量名称</td></tr><tr><td>EXECUTION_ID_</td><td>执行实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>执行的ID</td></tr><tr><td>PROC_INST_ID_</td><td>流程实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>流程实例ID</td></tr><tr><td>TASK_ID_</td><td>节点实例ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>节点实例ID(Local）</td></tr><tr><td>BYTEARRAY_ID_</td><td>字节表ID</td><td>nvarchar(64)</td><td></td><td>√</td><td>字节表的ID（ACT_GE_BYTEARRAY）</td></tr><tr><td>DOUBLE_</td><td>DOUBLE_</td><td>float</td><td></td><td>√</td><td>存储变量类型为Double</td></tr><tr><td>LONG_</td><td>LONG_</td><td>numeric(19)</td><td></td><td>√</td><td>存储变量类型为long</td></tr><tr><td>TEXT_</td><td>TEXT_</td><td>nvarchar(4000)</td><td></td><td>√</td><td>‘存储变量值类型为String 如此处存储持久化对象时，值jpa对象的class</td></tr><tr><td>TEXT2_</td><td>TEXT2_</td><td>nvarchar(4000)</td><td></td><td>√</td><td>此处存储的是JPA持久化对象时，才会有值。此值为对象ID</td></tr></tbody></table><hr><p>关注我的微信公众号：FramePower<br>我会不定期发布相关技术积累，欢迎对技术有追求、志同道合的朋友加入，一起学习成长！</p><hr><p><img src="https://artislong.oss-cn-hangzhou.aliyuncs.com/images/%E5%BE%AE%E4%BF%A1%E5%85%AC%E4%BC%97%E5%8F%B7/%E5%BE%AE%E4%BF%A1%E5%85%AC%E4%BC%97%E5%8F%B71.png" alt="微信公众号"></p><div class="reward"><div class="reward-button">赏 <span class="reward-code"><span class="alipay-code"><img class="alipay-img wdp-appear" src="/css/images/alipay.jpeg"></span> <span class="wechat-code"><img class="wechat-img wdp-appear" src="/css/images/Wechat.jpeg"></span></span></div><p class="reward-notice">如果文章对你有帮助，欢迎点击上方按钮打赏作者</p></div></div><footer class="article-footer"><div class="share-container"><div class="bdsharebuttonbox"> <a href="#" class="bds_more" data-cmd="more">分享到：</a> <a href="#" class="bds_qzone" data-cmd="qzone" title="分享到QQ空间">QQ空间</a> <a href="#" class="bds_tsina" data-cmd="tsina" title="分享到新浪微博">新浪微博</a> <a href="#" class="bds_tqq" data-cmd="tqq" title="分享到腾讯微博">腾讯微博</a> <a href="#" class="bds_renren" data-cmd="renren" title="分享到人人网">人人网</a> <a href="#" class="bds_weixin" data-cmd="weixin" title="分享到微信">微信</a></div><script>with(window._bd_share_config={common:{bdSnsKey:{},bdText:"",bdMini:"2",bdMiniList:!1,bdPic:"",bdStyle:"0",bdSize:"16"},share:{bdSize:16}},document)(getElementsByTagName("head")[0]||body).appendChild(createElement("script")).src="http://bdimg.share.baidu.com/static/api/js/share.js?v=89860593.js?cdnversion="+~(-new Date/36e5)</script><style>.bdshare_popup_box{border-radius:4px;border:#e1e1e1 solid 1px}.bdshare-button-style0-16 .bds_more,.bdshare-button-style0-16 a{padding-left:20px;margin:6px 10px 6px 0}.bdshare_dialog_list a,.bdshare_popup_bottom a,.bdshare_popup_list a{font-family:'Microsoft Yahei'}.bdshare_popup_top{display:none}.bdshare_popup_bottom{height:auto;padding:5px}</style></div></footer></div><nav id="article-nav"> <a href="/2018/07/28/IDEA-常用插件/" id="article-nav-newer" class="article-nav-link-wrap"><strong class="article-nav-caption">上一篇</strong><div class="article-nav-title"> IDEA常用插件</div></a> <a href="/2018/03/21/Tomcat源码分析之启动流程分析/" id="article-nav-older" class="article-nav-link-wrap"><strong class="article-nav-caption">下一篇</strong><div class="article-nav-title">Tomcat源码分析之启动流程分析</div></a></nav></article><section id="comments"></section></section><aside id="sidebar"><div class="widget-wrap"><h3 class="widget-title">最新文章</h3><div class="widget"><ul id="recent-post" class=""><li><div class="item-thumbnail"><a href="/2019/07/14/SpringBoot完美整合Jfinal/" class="thumbnail"><span class="thumbnail-image thumbnail-none"></span></a></div><div class="item-inner"><p class="item-category"><a class="article-category-link" href="/categories/SpringBoot/">SpringBoot</a></p><p class="item-title"><a href="/2019/07/14/SpringBoot完美整合Jfinal/" class="title">SpringBoot完美整合Jfinal</a></p><p class="item-date"><time datetime="2019-07-14T15:32:31.000Z" itemprop="datePublished">2019-07-14 23:32:31</time></p></div></li><li><div class="item-thumbnail"><a href="/2019/06/27/SpringBoot集成Flowable-UI/" class="thumbnail"><span class="thumbnail-image thumbnail-none"></span></a></div><div class="item-inner"><p class="item-category"><a class="article-category-link" href="/categories/工作流/">工作流</a><i class="fas fa-angle-right"></i><a class="article-category-link" href="/categories/工作流/Flowable/">Flowable</a></p><p class="item-title"><a href="/2019/06/27/SpringBoot集成Flowable-UI/" class="title">SpringBoot集成Flowable UI</a></p><p class="item-date"><time datetime="2019-06-26T16:27:21.000Z" itemprop="datePublished">2019-06-27 00:27:21</time></p></div></li><li><div class="item-thumbnail"><a href="/2019/05/25/Flowable五个引擎及相关服务总结/" class="thumbnail"><span class="thumbnail-image thumbnail-none"></span></a></div><div class="item-inner"><p class="item-category"><a class="article-category-link" href="/categories/工作流/">工作流</a><i class="fas fa-angle-right"></i><a class="article-category-link" href="/categories/工作流/Flowable/">Flowable</a></p><p class="item-title"><a href="/2019/05/25/Flowable五个引擎及相关服务总结/" class="title">Flowable五个引擎及相关服务总结</a></p><p class="item-date"><time datetime="2019-05-25T15:43:07.000Z" itemprop="datePublished">2019-05-25 23:43:07</time></p></div></li><li><div class="item-thumbnail"><a href="/2019/03/01/微服务基础概念认知总结/" class="thumbnail"><span class="thumbnail-image thumbnail-none"></span></a></div><div class="item-inner"><p class="item-category"><a class="article-category-link" href="/categories/思考/">思考</a></p><p class="item-title"><a href="/2019/03/01/微服务基础概念认知总结/" class="title">微服务基础概念认知总结</a></p><p class="item-date"><time datetime="2019-03-01T15:17:33.000Z" itemprop="datePublished">2019-03-01 23:17:33</time></p></div></li><li><div class="item-thumbnail"><a href="/2019/03/01/Oracle-SQL优化总结/" class="thumbnail"><span class="thumbnail-image thumbnail-none"></span></a></div><div class="item-inner"><p class="item-category"><a class="article-category-link" href="/categories/Oracle/">Oracle</a></p><p class="item-title"><a href="/2019/03/01/Oracle-SQL优化总结/" class="title">Oracle SQL优化总结</a></p><p class="item-date"><time datetime="2019-03-01T07:30:47.000Z" itemprop="datePublished">2019-03-01 15:30:47</time></p></div></li></ul></div></div><div class="widget-wrap"><h3 class="widget-title">分类</h3><div class="widget"><ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/categories/Alibaba/">Alibaba</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Docker/">Docker</a><span class="category-list-count">3</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Git/">Git</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Java基础/">Java基础</a><span class="category-list-count">4</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Nginx/">Nginx</a><span class="category-list-count">3</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Oracle/">Oracle</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Redis/">Redis</a><span class="category-list-count">2</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Shiro/">Shiro</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Spring/">Spring</a><span class="category-list-count">2</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/SpringBoot/">SpringBoot</a><span class="category-list-count">7</span><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/categories/SpringBoot/Shiro/">Shiro</a><span class="category-list-count">1</span></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/categories/Storm/">Storm</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Tomcat/">Tomcat</a><span class="category-list-count">2</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Zookeeper/">Zookeeper</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/工作流/">工作流</a><span class="category-list-count">3</span><ul class="category-list-child"><li class="category-list-item"><a class="category-list-link" href="/categories/工作流/Activiti/">Activiti</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/工作流/Flowable/">Flowable</a><span class="category-list-count">2</span></li></ul></li><li class="category-list-item"><a class="category-list-link" href="/categories/工具/">工具</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/开发工具框架/">开发工具框架</a><span class="category-list-count">3</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/思考/">思考</a><span class="category-list-count">2</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/服务器/">服务器</a><span class="category-list-count">1</span></li></ul></div></div><div class="widget-wrap"><h3 class="widget-title">归档</h3><div class="widget"><ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/07/">七月 2019</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/06/">六月 2019</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/05/">五月 2019</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/03/">三月 2019</a><span class="archive-list-count">2</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/02/">二月 2019</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/01/">一月 2019</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/12/">十二月 2018</a><span class="archive-list-count">6</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/11/">十一月 2018</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/08/">八月 2018</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/07/">七月 2018</a><span class="archive-list-count">2</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/03/">三月 2018</a><span class="archive-list-count">3</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/02/">二月 2018</a><span class="archive-list-count">2</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2018/01/">一月 2018</a><span class="archive-list-count">2</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2017/12/">十二月 2017</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2017/10/">十月 2017</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2017/09/">九月 2017</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2017/06/">六月 2017</a><span class="archive-list-count">7</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2016/12/">十二月 2016</a><span class="archive-list-count">4</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2016/07/">七月 2016</a><span class="archive-list-count">1</span></li></ul></div></div><div class="widget-wrap"><h3 class="widget-title">标签</h3><div class="widget"><ul class="tag-list"><li class="tag-list-item"><a class="tag-list-link" href="/tags/Alibaba/">Alibaba</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Docker/">Docker</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Git/">Git</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Idea/">Idea</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Jackson/">Jackson</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Java基础/">Java基础</a><span class="tag-list-count">4</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Lombok/">Lombok</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Nginx/">Nginx</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Oracle/">Oracle</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Quartz/">Quartz</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Redis/">Redis</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Session/">Session</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Shiro/">Shiro</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Spring/">Spring</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/SpringBoot/">SpringBoot</a><span class="tag-list-count">7</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Storm/">Storm</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Swagger/">Swagger</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Tomcat/">Tomcat</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/Zookeeper/">Zookeeper</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/前后端分离/">前后端分离</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/多数据源/">多数据源</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/工作流/">工作流</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/工具/">工具</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/开发工具框架/">开发工具框架</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/微服务/">微服务</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/数据库/">数据库</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/负载均衡/">负载均衡</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/集群/">集群</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/面试题/">面试题</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/项目架构/">项目架构</a><span class="tag-list-count">2</span></li></ul></div></div><div class="widget-wrap"><h3 class="widget-title">标签云</h3><div class="widget tagcloud"> <a href="/tags/Alibaba/" style="font-size:10px">Alibaba</a> <a href="/tags/Docker/" style="font-size:15px">Docker</a> <a href="/tags/Git/" style="font-size:10px">Git</a> <a href="/tags/Idea/" style="font-size:10px">Idea</a> <a href="/tags/Jackson/" style="font-size:10px">Jackson</a> <a href="/tags/Java基础/" style="font-size:17.5px">Java基础</a> <a href="/tags/Lombok/" style="font-size:10px">Lombok</a> <a href="/tags/Nginx/" style="font-size:15px">Nginx</a> <a href="/tags/Oracle/" style="font-size:10px">Oracle</a> <a href="/tags/Quartz/" style="font-size:10px">Quartz</a> <a href="/tags/Redis/" style="font-size:12.5px">Redis</a> <a href="/tags/Session/" style="font-size:10px">Session</a> <a href="/tags/Shiro/" style="font-size:12.5px">Shiro</a> <a href="/tags/Spring/" style="font-size:12.5px">Spring</a> <a href="/tags/SpringBoot/" style="font-size:20px">SpringBoot</a> <a href="/tags/Storm/" style="font-size:10px">Storm</a> <a href="/tags/Swagger/" style="font-size:12.5px">Swagger</a> <a href="/tags/Tomcat/" style="font-size:12.5px">Tomcat</a> <a href="/tags/Zookeeper/" style="font-size:10px">Zookeeper</a> <a href="/tags/前后端分离/" style="font-size:10px">前后端分离</a> <a href="/tags/多数据源/" style="font-size:10px">多数据源</a> <a href="/tags/工作流/" style="font-size:15px">工作流</a> <a href="/tags/工具/" style="font-size:10px">工具</a> <a href="/tags/开发工具框架/" style="font-size:15px">开发工具框架</a> <a href="/tags/微服务/" style="font-size:10px">微服务</a> <a href="/tags/数据库/" style="font-size:10px">数据库</a> <a href="/tags/负载均衡/" style="font-size:10px">负载均衡</a> <a href="/tags/集群/" style="font-size:10px">集群</a> <a href="/tags/面试题/" style="font-size:10px">面试题</a> <a href="/tags/项目架构/" style="font-size:12.5px">项目架构</a></div></div><div class="widget-wrap widget-list"><h3 class="widget-title">链接</h3><div class="widget"><ul><li> <a href="https://www.xiefayang.com">i蝸居年華_谢谢谢</a></li><li> <a href="http://fullsmilespace.com">微笑空间站</a></li></ul></div></div><div id="toTop" class="fas fa-angle-up"></div></aside></div><footer id="footer"><div class="outer"><div id="footer-info" class="inner"> &copy; 2020 ArtIsLong的博客<br> Powered by <a href="http://hexo.io/" target="_blank">Hexo</a>. Theme by <a href="http://github.com/ppoffice">PPOffice</a></div></div><script async src="//busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js"></script></footer><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/gitalk@1/dist/gitalk.css"><script src="https://cdn.jsdelivr.net/npm/gitalk@1/dist/gitalk.min.js"></script><script>if(document.getElementById("comments")){var id=decodeURI(window.location.pathname),gitalk=new Gitalk({id:id,owner:"ArtIsLong",repo:"ArtIsLong.github.io",admin:["ArtIsLong"],clientID:"2f97f5d71dbb65bf01e1",clientSecret:"f715a8e1507c1fef1c5e3cfaccef8f59aa734318",distractionFreeMode:!0,createIssueManually:!1,perPage:15});gitalk.render("comments")}</script><script src="/libs/lightgallery/js/lightgallery.min.js"></script><script src="/libs/lightgallery/js/lg-thumbnail.min.js"></script><script src="/libs/lightgallery/js/lg-pager.min.js"></script><script src="/libs/lightgallery/js/lg-autoplay.min.js"></script><script src="/libs/lightgallery/js/lg-fullscreen.min.js"></script><script src="/libs/lightgallery/js/lg-zoom.min.js"></script><script src="/libs/lightgallery/js/lg-hash.min.js"></script><script src="/libs/lightgallery/js/lg-share.min.js"></script><script src="/libs/lightgallery/js/lg-video.min.js"></script><script src="/libs/justified-gallery/jquery.justifiedGallery.min.js"></script><script src="/js/main.js"></script></div><script>((window.gitter={}).chat={}).options={room:"artislong/Lobby"}</script><script src="https://sidecar.gitter.im/dist/sidecar.v1.js" async defer="defer"></script><script type="text/javascript" color="0,0,255" opacity="0.7" zindex="-2" count="99" src="//cdn.bootcss.com/canvas-nest.js/1.0.0/canvas-nest.min.js"></script><script async custom-element="amp-auto-ads" src="https://cdn.ampproject.org/v0/amp-auto-ads-0.1.js"></script></body>